package com.itheima.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itheima.pojo.TbClue;
import org.apache.ibatis.annotations.Param;
import org.springframework.data.domain.Pageable;

import java.util.Date;
import java.util.List;

/**
 * 线索(TbClue)表数据库访问层
 *
 * @author makejava
 * @since 2022-01-16 15:48:53
 */
public interface TbClueDao extends BaseMapper<TbClue> {



    TbClue selectByPhone(@Param("phone") String phone);

    int updateTransfer(@Param("userId") Long userId);

    int updateStatus(@Param("id") Long id,@Param("status") String status);

    Integer getByTime(@Param("startTime")  Date startTime, @Param("nextTime") Date nextTime);

    Integer selectCountNotFByTime(
            @Param("startTime") Date startTime,
            @Param("endTime") Date endTime,
            @Param("status") String status
    );

    List<TbClue> selectByActivityId(Long activityId);
}

